<%@ page  import="java.sql.*" contentType="text/html;charset=windows-1252"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<!-- saved from url=(0030)http://www.phrack.org/show.php -->
<HTML><HEAD><TITLE>www.phrack.org</TITLE>
<META http-equiv=Content-Type content="text/html; charset=windows-1252">
<META content="Microsoft FrontPage 5.0" name=GENERATOR></HEAD>
<%   
   String webRoot="iran_hacker2";
   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
   String url = "jdbc:odbc:iranhk";
   Connection con = DriverManager.getConnection(url, "iranhk", "iranhk");
   PreparedStatement pst=con.prepareStatement(
    "select tb_members.id member_id,tb_members.name,qq1.num articles,qq2.num tools "+
     "from tb_members, "+
          "(select tb_members.id,nvl(q1.num,0) num "+
            "from tb_members, "+
              "(select tb_articles.fk_author_id auth_id,count(tb_articles.id) num "+
               "from tb_articles "+
               "group by tb_articles.fk_author_id) q1 "+
           "where (q1.auth_id(+)=tb_members.id)) qq1 "+
     ","+
          "(select tb_members.id,nvl(q1.num,0) num "+
             "from tb_members, "  +
                 "(select tb_tools.fk_author_id auth_id,count(tb_tools.id) num "+
                   "from tb_tools "+
                   "group by tb_tools.fk_author_id) q1 "+
           "where (q1.auth_id(+)=tb_members.id)) qq2 "+
     "where "+
    "(qq1.id=tb_members.id) and "+
    "(qq2.id=tb_members.id);"
  );
   ResultSet rst=pst.executeQuery();  
%>   
<BODY text=#cfcfcf vLink=lightblue aLink=white link=skyblue bgColor=#000000 
leftMargin=0 topMargin=0 border="0" marginright="0" marginheight="0" 
marginwith="0">
<br>
<TABLE cellSpacing=0 cellPadding=1 width="70%" align=center bgColor=#0000a8 
border=0>
  <TBODY>
  <TR>
    <TD>
      <TABLE cellSpacing=1 cellPadding=0 width="100%" bgColor=#000044 
        border=0><TBODY>
        <TR>
          <TD bgColor=#000066>
            <TABLE cellSpacing=3 cellPadding=3 width="473" bgColor=#000066 
            border=0>
              <TBODY>
              <TR> <!-- my title section -->
                <TD width="133" align="center"><B><FONT face=Lucida,Verdana,Helvetica,Arial>
                  author
                </FONT></B></TD>
                <TD width="171" align="center"><B><FONT face=Lucida,Verdana,Helvetica,Arial>
                  articles
                </FONT></B></TD>
                <TD width="139" align="center"><B><FONT face=Lucida,Verdana,Helvetica,Arial>
                  tools
                </FONT></B></TD>              
                </TR></TBODY></TABLE></TD></TR>       
        <TR> <!--detail section-->
          <TD>
            <TABLE cellSpacing=0 cellPadding=4 width="473" bgColor=#000044 
            border=0>
              <TBODY>
<% 
  int r=0;
  while (rst.next()){   
   int member_id=rst.getInt("MEMBER_ID");
   String name=rst.getString("NAME");
   int articlesNum=rst.getInt("ARTICLES");
   int toolsNum=rst.getInt("TOOLS");
%>  
              <TR width="100%" align="center"
                <%if ((r%2)==1) {out.print(" bgColor=#000066 ");}%>
              >
                <TD align="center" width="137"><SMALL><FONT face=Lucida,Verdana,Helvetica,Arial>
                  <A href="../download/userProfile.jsp?ID=<%=member_id%>">
                   <%=name%>
                  </A> 
                </FONT></SMALL></TD>
                <TD align="center" width="169"><SMALL><FONT face=Lucida,Verdana,Helvetica,Arial>
                       <%=articlesNum%>
                </FONT></SMALL></TD>
                <TD align=center width="143">
                <SMALL><FONT face=Lucida,Verdana,Helvetica,Arial>
                    <%=toolsNum%>      
                </FONT></SMALL></TD></TR>
<%r++;}%>
      
             </TBODY></TABLE></TD></TR></TBODY></TABLE>

</BODY></HTML>
<%
  rst.close();
  con.close();
%>